package com.wx.annotation.inf;

import com.wx.annotation.Delete;
import com.wx.annotation.Insert;
import com.wx.annotation.Select;
import com.wx.annotation.Update;

import java.util.List;

/**
 * @author shkstart
 * @create 2020-05-06 9:53
 */
public interface UserMapper {
    @Insert("insert into user (id, name, sex, age, isDelete) values (?,?,?,?,?)")
    public void addUser(String id, String name, String sex, Integer age, Boolean isDelete);

    @Update("update user set set = ? ,age = ? ,isDelete=? where id = ?")
    public void updateUser(String id,String name,String sex,Integer age,Boolean isDelete) ;

    @Delete("delete from user where id = ? ")
    public void delete(String id);

    @Select("select * fom user ")
    public List selectAll();

}
